Average Non Graded Days KPI Card 18
Step 1: Create Avg Non Graded Days KPI Card
- Choose KPI card Visual
- Indicator = Average Non Graded Days, Trend Axis = DateEntered / Year, Target goals = Avg Non Graded Days Goals
- Select Format under General X position = 230, Y position = 143, Width = 289, Height = 160
- Indicator = Text size = 45, font family = Constantia, Horizontal alignment = Center, Vertical alignment = top
- Trend Axis on
- Goals on = Font color = black, font family = Constantia, text size = 12
- Color coding = low is good
- Title on = Avg Non Graded Days, font color = black, background color = light blue, alignment = centered, text size = 12, font family = Constantia
- Border = light gray
- Shadow on
Step 2: Create KPI Background
- Choose stacked area chart visual
- Axis = Rolling Weeks, Values = Average of Non Graded Days
- Select Format under General X position = 232, Y position = 172, Width = 292, Height = 137
- Turn off X Axis and X Axis title
- Turn off Y Axis and Y Axis title
- Title is off
- Background = Transparency should be 100%
How to create KPI card ?
https://docs.microsoft.com/en-us/power-bi/create-reports/service-aggregates